﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="ryxx.aspx.cs" Inherits="ryxx" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
    AllowSorting="True" AutoGenerateColumns="False" 
    DataSourceID="SqlDataSourceryxx" EnableModelValidation="True" Width="499px">
    <Columns>
        <asp:BoundField DataField="cusID" HeaderText="cusID" SortExpression="cusID" />
        <asp:BoundField DataField="c_Name" HeaderText="c_Name" 
            SortExpression="c_Name" />
        <asp:BoundField DataField="bm" HeaderText="bm" SortExpression="bm" />
        <asp:BoundField DataField="bgsdz" HeaderText="bgsdz" SortExpression="bgsdz" />
        <asp:BoundField DataField="zjdh" HeaderText="zjdh" SortExpression="zjdh" />
        <asp:BoundField DataField="nxdh" HeaderText="nxdh" SortExpression="nxdh" />
        <asp:BoundField DataField="yddh" HeaderText="yddh" SortExpression="yddh" />
        <asp:BoundField DataField="className" HeaderText="className" 
            SortExpression="className" />
    </Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSourceryxx" runat="server" 
    ConnectionString="<%$ ConnectionStrings:qynbControlSystemConnectionString %>" 
    
    SelectCommand="SELECT cusInfo.cusID, cusInfo.c_Name, cusInfo.bm, cusInfo.bgsdz, cusInfo.zjdh, cusInfo.nxdh, cusInfo.yddh, classInfo.className FROM cusInfo INNER JOIN classInfo ON cusInfo.bm = classInfo.classID">
</asp:SqlDataSource>
</asp:Content>

